package es.exitae.ejerciciofinal.provedorCont.tablas;

import android.provider.BaseColumns;

public class Lugares implements BaseColumns
{
	public static final String TABLE_NAME = "lugares";
	public static final String DEFAULT_SORT_ORDER = "_ID DESC";

	public static final String COL_NOMBRE = "nombre";
	public static final String COL_DESCRIPCION = "descripcion";
	public static final String COL_LATITUD = "latitud";
	public static final String COL_LONGITUD = "longitud";
	public static final String COL_FOTO = "foto";

	public static String queryCreacionTabla()
	{
		StringBuilder query = new StringBuilder();

		query.append("CREATE TABLE [lugares] ( ");
		query.append("[_id] INTEGER  PRIMARY KEY AUTOINCREMENT, ");
		query.append("[nombre] TEXT  NULL, ");
		query.append("[descripcion] TEXT  NULL, ");
		query.append("[latitud] REAL  NULL, ");
		query.append("[longitud] REAL  NULL, ");
		query.append("[foto] TEXT  NULL )");

		return query.toString();
	}
}
